<?php
require_once ('include_paths.php');
require_once ('functions.php');
/**
 * Retrieves and modifies the config.php file.
 *
 * The permissions for the base directory must allow for writing files in order
 * for the config.php to be created using this page.

 */

/**
 * Disable error reporting
 *
 * Set this to error_reporting( E_ALL ) or error_reporting( E_ALL | E_STRICT ) for debugging
 */
error_reporting(NULL);



// **** TO DO Check versions of PHP and MySQL **********


if (!file_exists('../../config/config.php'))
	die("Sorry, I need a config.php file to work from. Please run the <a href='setup-config.php'>install</a> first.");

$configFile = file('../../config/config.php');
foreach ($configFile as $line_num => $line) {
	switch (substr($line,0,16)) {
		case '$GLOBALS["ORG_NA':
			$startPos = strpos($line, "= '") + 3;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$orgnameInput = substr ($line , $startPos, $strLen);
			break;
		case "define('DB_NAME'":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$dbnameInput = substr ($line , $startPos, $strLen);
			break;
		case "define('DB_USER'":
			$startPos = strpos($line, "', '") + 4;
			$strLen = strpos($line, "'", $startPos) -  $startPos;
			$unameInput = substr ($line , $startPos, $strLen);
			break;
		case "define('DB_PASS'":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$passwrdInput = substr ($line , $startPos, $strLen);
			break;
		case "define('DB_HOST'":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$dbhostInput = substr ($line , $startPos, $strLen);
			break;
		case "define('API_KEY'":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$apikeyInput = substr ($line , $startPos, $strLen);
			break;
		case "date_default_tim":
			$startPos = strpos($line, "('") + 2;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$defaultTimeZoneInput = substr ($line , $startPos, $strLen);
			break;
		case "define('TIME_ZON":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$timeZoneInput = substr ($line , $startPos, $strLen);
			break;
		
		case "define('SITE_NAM":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$siteNameInput = substr ($line , $startPos, $strLen);
			break;
		case "define('SITE_DES":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$tagLineInput = substr ($line , $startPos, $strLen);
			break;
		case "define('SITE_ROO":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$siteRootInput = substr ($line , $startPos, $strLen);
			break;
		case "define('LOGO', '":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$logoInput = substr ($line , $startPos, $strLen);
			break;
		case "define('LOGO_WID":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$widthInput = substr ($line , $startPos, $strLen);
			break;
		case "define('LOGO_HEI":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$heightInput = substr ($line , $startPos, $strLen);
			break;
		case "define('TOOL_TIP":
			$startPos = strpos($line, "', '") + 4;
			$strLen =  strpos($line, "'", $startPos) - $startPos;
			$tooltipInput = substr ($line , $startPos, $strLen);
			break;			
			
						
	}
}
if(!get_magic_quotes_gpc()) {
	$orgnameInput = stripslashes($orgnameInput);
	$dbnameInput = stripslashes($dbnameInput);
	$unameInput = stripslashes($unameInput);
	$passwrdInput = stripslashes($passwrdInput);
	$dbhostInput = stripslashes($dbhostInput);
	$siteNameInput = stripslashes($siteNameInput);
	$tagLineInput = stripslashes($tagLineInput);
	$tooltipInput = stripslashes($tooltipInput);
	
}
if (isset($_GET['step']))
	$step = $_GET['step'];
else
	$step = 1;


switch($step) {
	case 1:
	
		
		// not for use until php 5.3
	   /* $regions = array(
			'Africa' => DateTimeZone::AFRICA,
			'America' => DateTimeZone::AMERICA,
			'Antarctica' => DateTimeZone::ANTARCTICA,
			'Aisa' => DateTimeZone::ASIA,
			'Atlantic' => DateTimeZone::ATLANTIC,
			'Europe' => DateTimeZone::EUROPE,
			'Indian' => DateTimeZone::INDIAN,
			'Pacific' => DateTimeZone::PACIFIC
		);
		foreach ($regions as $name => $mask) {
			$tzlist[] = DateTimeZone::listIdentifiers($mask);
		}*/
	?>

<form method="post" action="settings.php?step=2" enctype="multipart/form-data">
  <table class="form-table">
    <tr>
      <th scope="row"><label for="orgname">Organization Name *</label></th>
      <td><input name="orgname" id="orgname" type="text" size="25" value="<?php echo $orgnameInput ?>" /></td>
      <td>The name of your organization. </td>
    </tr>
    <tr>
      <th scope="row" nowrap="nowrap"><label for="apikey">Google Maps API Key *</label></th>
      <td><input name="apikey" id="apikey" type="text" size="25" value="<?php echo $apikeyInput ?>" /></td>
      <td>Your Goole Maps API Key.  You can get a Goole Maps API key at <a href="http://code.google.com/apis/maps/signup.html" target="_blank">here.</a></td>
    </tr>
    <tr>
      <th scope="row"><label for="timeZone">Time Zone *</label></th>
      <td><select name="timeZone">
          <option value="<?php echo $timeZoneInput ?>"><?php echo $timeZoneInput ?></option>
          <option value="Africa/Abidjan">Africa/Abidjan</option>
          <option value="Africa/Accra">Africa/Accra</option>
          <option value="Africa/Addis_Ababa">Africa/Addis_Ababa</option>
          <option value="Africa/Algiers">Africa/Algiers</option>
          <option value="Africa/Asmara">Africa/Asmara</option>
          <option value="Africa/Bamako">Africa/Bamako</option>
          <option value="Africa/Bangui">Africa/Bangui</option>
          <option value="Africa/Banjul">Africa/Banjul</option>
          <option value="Africa/Bissau">Africa/Bissau</option>
          <option value="Africa/Blantyre">Africa/Blantyre</option>
          <option value="Africa/Brazzaville">Africa/Brazzaville</option>
          <option value="Africa/Bujumbura">Africa/Bujumbura</option>
          <option value="Africa/Cairo">Africa/Cairo</option>
          <option value="Africa/Casablanca">Africa/Casablanca</option>
          <option value="Africa/Ceuta">Africa/Ceuta</option>
          <option value="Africa/Conakry">Africa/Conakry</option>
          <option value="Africa/Dakar">Africa/Dakar</option>
          <option value="Africa/Dar_es_Salaam">Africa/Dar_es_Salaam</option>
          <option value="Africa/Djibouti">Africa/Djibouti</option>
          <option value="Africa/Douala">Africa/Douala</option>
          <option value="Africa/El_Aaiun">Africa/El_Aaiun</option>
          <option value="Africa/Freetown">Africa/Freetown</option>
          <option value="Africa/Gaborone">Africa/Gaborone</option>
          <option value="Africa/Harare">Africa/Harare</option>
          <option value="Africa/Johannesburg">Africa/Johannesburg</option>
          <option value="Africa/Kampala">Africa/Kampala</option>
          <option value="Africa/Khartoum">Africa/Khartoum</option>
          <option value="Africa/Kigali">Africa/Kigali</option>
          <option value="Africa/Kinshasa">Africa/Kinshasa</option>
          <option value="Africa/Lagos">Africa/Lagos</option>
          <option value="Africa/Libreville">Africa/Libreville</option>
          <option value="Africa/Lome">Africa/Lome</option>
          <option value="Africa/Luanda">Africa/Luanda</option>
          <option value="Africa/Lubumbashi">Africa/Lubumbashi</option>
          <option value="Africa/Lusaka">Africa/Lusaka</option>
          <option value="Africa/Malabo">Africa/Malabo</option>
          <option value="Africa/Maputo">Africa/Maputo</option>
          <option value="Africa/Maseru">Africa/Maseru</option>
          <option value="Africa/Mbabane">Africa/Mbabane</option>
          <option value="Africa/Mogadishu">Africa/Mogadishu</option>
          <option value="Africa/Monrovia">Africa/Monrovia</option>
          <option value="Africa/Nairobi">Africa/Nairobi</option>
          <option value="Africa/Ndjamena">Africa/Ndjamena</option>
          <option value="Africa/Niamey">Africa/Niamey</option>
          <option value="Africa/Nouakchott">Africa/Nouakchott</option>
          <option value="Africa/Ouagadougou">Africa/Ouagadougou</option>
          <option value="Africa/Porto-Novo">Africa/Porto-Novo</option>
          <option value="Africa/Sao_Tome">Africa/Sao_Tome</option>
          <option value="Africa/Tripoli">Africa/Tripoli</option>
          <option value="Africa/Tunis">Africa/Tunis</option>
          <option value="Africa/Windhoek">Africa/Windhoek</option>
          <option value="America/Adak">America/Adak</option>
          <option value="America/Anchorage">America/Anchorage</option>
          <option value="America/Anguilla">America/Anguilla</option>
          <option value="America/Antigua">America/Antigua</option>
          <option value="America/Araguaina">America/Araguaina</option>
          <option value="America/Argentina/Buenos_Aires">America/Argentina/Buenos_Aires</option>
          <option value="America/Argentina/Catamarca">America/Argentina/Catamarca</option>
          <option value="America/Argentina/Cordoba">America/Argentina/Cordoba</option>
          <option value="America/Argentina/Jujuy">America/Argentina/Jujuy</option>
          <option value="America/Argentina/La_Rioja">America/Argentina/La_Rioja</option>
          <option value="America/Argentina/Mendoza">America/Argentina/Mendoza</option>
          <option value="America/Argentina/Rio_Gallegos">America/Argentina/Rio_Gallegos</option>
          <option value="America/Argentina/Salta">America/Argentina/Salta</option>
          <option value="America/Argentina/San_Juan">America/Argentina/San_Juan</option>
          <option value="America/Argentina/San_Luis">America/Argentina/San_Luis</option>
          <option value="America/Argentina/Tucuman">America/Argentina/Tucuman</option>
          <option value="America/Argentina/Ushuaia">America/Argentina/Ushuaia</option>
          <option value="America/Aruba">America/Aruba</option>
          <option value="America/Asuncion">America/Asuncion</option>
          <option value="America/Atikokan">America/Atikokan</option>
          <option value="America/Bahia">America/Bahia</option>
          <option value="America/Bahia_Banderas">America/Bahia_Banderas</option>
          <option value="America/Barbados">America/Barbados</option>
          <option value="America/Belem">America/Belem</option>
          <option value="America/Belize">America/Belize</option>
          <option value="America/Blanc-Sablon">America/Blanc-Sablon</option>
          <option value="America/Boa_Vista">America/Boa_Vista</option>
          <option value="America/Bogota">America/Bogota</option>
          <option value="America/Boise">America/Boise</option>
          <option value="America/Cambridge_Bay">America/Cambridge_Bay</option>
          <option value="America/Campo_Grande">America/Campo_Grande</option>
          <option value="America/Cancun">America/Cancun</option>
          <option value="America/Caracas">America/Caracas</option>
          <option value="America/Cayenne">America/Cayenne</option>
          <option value="America/Cayman">America/Cayman</option>
          <option value="America/Chicago">America/Chicago</option>
          <option value="America/Chihuahua">America/Chihuahua</option>
          <option value="America/Costa_Rica">America/Costa_Rica</option>
          <option value="America/Cuiaba">America/Cuiaba</option>
          <option value="America/Curacao">America/Curacao</option>
          <option value="America/Danmarkshavn">America/Danmarkshavn</option>
          <option value="America/Dawson">America/Dawson</option>
          <option value="America/Dawson_Creek">America/Dawson_Creek</option>
          <option value="America/Denver">America/Denver</option>
          <option value="America/Detroit">America/Detroit</option>
          <option value="America/Dominica">America/Dominica</option>
          <option value="America/Edmonton">America/Edmonton</option>
          <option value="America/Eirunepe">America/Eirunepe</option>
          <option value="America/El_Salvador">America/El_Salvador</option>
          <option value="America/Fortaleza">America/Fortaleza</option>
          <option value="America/Glace_Bay">America/Glace_Bay</option>
          <option value="America/Godthab">America/Godthab</option>
          <option value="America/Goose_Bay">America/Goose_Bay</option>
          <option value="America/Grand_Turk">America/Grand_Turk</option>
          <option value="America/Grenada">America/Grenada</option>
          <option value="America/Guadeloupe">America/Guadeloupe</option>
          <option value="America/Guatemala">America/Guatemala</option>
          <option value="America/Guayaquil">America/Guayaquil</option>
          <option value="America/Guyana">America/Guyana</option>
          <option value="America/Halifax">America/Halifax</option>
          <option value="America/Havana">America/Havana</option>
          <option value="America/Hermosillo">America/Hermosillo</option>
          <option value="America/Indiana/Indianapolis">America/Indiana/Indianapolis</option>
          <option value="America/Indiana/Knox">America/Indiana/Knox</option>
          <option value="America/Indiana/Marengo">America/Indiana/Marengo</option>
          <option value="America/Indiana/Petersburg">America/Indiana/Petersburg</option>
          <option value="America/Indiana/Tell_City">America/Indiana/Tell_City</option>
          <option value="America/Indiana/Vevay">America/Indiana/Vevay</option>
          <option value="America/Indiana/Vincennes">America/Indiana/Vincennes</option>
          <option value="America/Indiana/Winamac">America/Indiana/Winamac</option>
          <option value="America/Inuvik">America/Inuvik</option>
          <option value="America/Iqaluit">America/Iqaluit</option>
          <option value="America/Jamaica">America/Jamaica</option>
          <option value="America/Juneau">America/Juneau</option>
          <option value="America/Kentucky/Louisville">America/Kentucky/Louisville</option>
          <option value="America/Kentucky/Monticello">America/Kentucky/Monticello</option>
          <option value="America/La_Paz">America/La_Paz</option>
          <option value="America/Lima">America/Lima</option>
          <option value="America/Los_Angeles">America/Los_Angeles</option>
          <option value="America/Maceio">America/Maceio</option>
          <option value="America/Managua">America/Managua</option>
          <option value="America/Manaus">America/Manaus</option>
          <option value="America/Marigot">America/Marigot</option>
          <option value="America/Martinique">America/Martinique</option>
          <option value="America/Matamoros">America/Matamoros</option>
          <option value="America/Mazatlan">America/Mazatlan</option>
          <option value="America/Menominee">America/Menominee</option>
          <option value="America/Merida">America/Merida</option>
          <option value="America/Metlakatla">America/Metlakatla</option>
          <option value="America/Mexico_City">America/Mexico_City</option>
          <option value="America/Miquelon">America/Miquelon</option>
          <option value="America/Moncton">America/Moncton</option>
          <option value="America/Monterrey">America/Monterrey</option>
          <option value="America/Montevideo">America/Montevideo</option>
          <option value="America/Montreal">America/Montreal</option>
          <option value="America/Montserrat">America/Montserrat</option>
          <option value="America/Nassau">America/Nassau</option>
          <option value="America/New_York">America/New_York</option>
          <option value="America/Nipigon">America/Nipigon</option>
          <option value="America/Nome">America/Nome</option>
          <option value="America/Noronha">America/Noronha</option>
          <option value="America/North_Dakota/Beulah">America/North_Dakota/Beulah</option>
          <option value="America/North_Dakota/Center">America/North_Dakota/Center</option>
          <option value="America/North_Dakota/New_Salem">America/North_Dakota/New_Salem</option>
          <option value="America/Ojinaga">America/Ojinaga</option>
          <option value="America/Panama">America/Panama</option>
          <option value="America/Pangnirtung">America/Pangnirtung</option>
          <option value="America/Paramaribo">America/Paramaribo</option>
          <option value="America/Phoenix">America/Phoenix</option>
          <option value="America/Port-au-Prince">America/Port-au-Prince</option>
          <option value="America/Port_of_Spain">America/Port_of_Spain</option>
          <option value="America/Porto_Velho">America/Porto_Velho</option>
          <option value="America/Puerto_Rico">America/Puerto_Rico</option>
          <option value="America/Rainy_River">America/Rainy_River</option>
          <option value="America/Rankin_Inlet">America/Rankin_Inlet</option>
          <option value="America/Recife">America/Recife</option>
          <option value="America/Regina">America/Regina</option>
          <option value="America/Resolute">America/Resolute</option>
          <option value="America/Rio_Branco">America/Rio_Branco</option>
          <option value="America/Santa_Isabel">America/Santa_Isabel</option>
          <option value="America/Santarem">America/Santarem</option>
          <option value="America/Santiago">America/Santiago</option>
          <option value="America/Santo_Domingo">America/Santo_Domingo</option>
          <option value="America/Sao_Paulo">America/Sao_Paulo</option>
          <option value="America/Scoresbysund">America/Scoresbysund</option>
          <option value="America/Shiprock">America/Shiprock</option>
          <option value="America/Sitka">America/Sitka</option>
          <option value="America/St_Barthelemy">America/St_Barthelemy</option>
          <option value="America/St_Johns">America/St_Johns</option>
          <option value="America/St_Kitts">America/St_Kitts</option>
          <option value="America/St_Lucia">America/St_Lucia</option>
          <option value="America/St_Thomas">America/St_Thomas</option>
          <option value="America/St_Vincent">America/St_Vincent</option>
          <option value="America/Swift_Current">America/Swift_Current</option>
          <option value="America/Tegucigalpa">America/Tegucigalpa</option>
          <option value="America/Thule">America/Thule</option>
          <option value="America/Thunder_Bay">America/Thunder_Bay</option>
          <option value="America/Tijuana">America/Tijuana</option>
          <option value="America/Toronto">America/Toronto</option>
          <option value="America/Tortola">America/Tortola</option>
          <option value="America/Vancouver">America/Vancouver</option>
          <option value="America/Whitehorse">America/Whitehorse</option>
          <option value="America/Winnipeg">America/Winnipeg</option>
          <option value="America/Yakutat">America/Yakutat</option>
          <option value="America/Yellowknife">America/Yellowknife</option>
          <option value="Antarctica/Casey">Antarctica/Casey</option>
          <option value="Antarctica/Davis">Antarctica/Davis</option>
          <option value="Antarctica/DumontDUrville">Antarctica/DumontDUrville</option>
          <option value="Antarctica/Macquarie">Antarctica/Macquarie</option>
          <option value="Antarctica/Mawson">Antarctica/Mawson</option>
          <option value="Antarctica/McMurdo">Antarctica/McMurdo</option>
          <option value="Antarctica/Palmer">Antarctica/Palmer</option>
          <option value="Antarctica/Rothera">Antarctica/Rothera</option>
          <option value="Antarctica/South_Pole">Antarctica/South_Pole</option>
          <option value="Antarctica/Syowa">Antarctica/Syowa</option>
          <option value="Antarctica/Vostok">Antarctica/Vostok</option>
          <option value="Asia/Aden">Asia/Aden</option>
          <option value="Asia/Almaty">Asia/Almaty</option>
          <option value="Asia/Amman">Asia/Amman</option>
          <option value="Asia/Anadyr">Asia/Anadyr</option>
          <option value="Asia/Aqtau">Asia/Aqtau</option>
          <option value="Asia/Aqtobe">Asia/Aqtobe</option>
          <option value="Asia/Ashgabat">Asia/Ashgabat</option>
          <option value="Asia/Baghdad">Asia/Baghdad</option>
          <option value="Asia/Bahrain">Asia/Bahrain</option>
          <option value="Asia/Baku">Asia/Baku</option>
          <option value="Asia/Bangkok">Asia/Bangkok</option>
          <option value="Asia/Beirut">Asia/Beirut</option>
          <option value="Asia/Bishkek">Asia/Bishkek</option>
          <option value="Asia/Brunei">Asia/Brunei</option>
          <option value="Asia/Choibalsan">Asia/Choibalsan</option>
          <option value="Asia/Chongqing">Asia/Chongqing</option>
          <option value="Asia/Colombo">Asia/Colombo</option>
          <option value="Asia/Damascus">Asia/Damascus</option>
          <option value="Asia/Dhaka">Asia/Dhaka</option>
          <option value="Asia/Dili">Asia/Dili</option>
          <option value="Asia/Dubai">Asia/Dubai</option>
          <option value="Asia/Dushanbe">Asia/Dushanbe</option>
          <option value="Asia/Gaza">Asia/Gaza</option>
          <option value="Asia/Harbin">Asia/Harbin</option>
          <option value="Asia/Ho_Chi_Minh">Asia/Ho_Chi_Minh</option>
          <option value="Asia/Hong_Kong">Asia/Hong_Kong</option>
          <option value="Asia/Hovd">Asia/Hovd</option>
          <option value="Asia/Irkutsk">Asia/Irkutsk</option>
          <option value="Asia/Jakarta">Asia/Jakarta</option>
          <option value="Asia/Jayapura">Asia/Jayapura</option>
          <option value="Asia/Jerusalem">Asia/Jerusalem</option>
          <option value="Asia/Kabul">Asia/Kabul</option>
          <option value="Asia/Kamchatka">Asia/Kamchatka</option>
          <option value="Asia/Karachi">Asia/Karachi</option>
          <option value="Asia/Kashgar">Asia/Kashgar</option>
          <option value="Asia/Kathmandu">Asia/Kathmandu</option>
          <option value="Asia/Kolkata">Asia/Kolkata</option>
          <option value="Asia/Krasnoyarsk">Asia/Krasnoyarsk</option>
          <option value="Asia/Kuala_Lumpur">Asia/Kuala_Lumpur</option>
          <option value="Asia/Kuching">Asia/Kuching</option>
          <option value="Asia/Kuwait">Asia/Kuwait</option>
          <option value="Asia/Macau">Asia/Macau</option>
          <option value="Asia/Magadan">Asia/Magadan</option>
          <option value="Asia/Makassar">Asia/Makassar</option>
          <option value="Asia/Manila">Asia/Manila</option>
          <option value="Asia/Muscat">Asia/Muscat</option>
          <option value="Asia/Nicosia">Asia/Nicosia</option>
          <option value="Asia/Novokuznetsk">Asia/Novokuznetsk</option>
          <option value="Asia/Novosibirsk">Asia/Novosibirsk</option>
          <option value="Asia/Omsk">Asia/Omsk</option>
          <option value="Asia/Oral">Asia/Oral</option>
          <option value="Asia/Phnom_Penh">Asia/Phnom_Penh</option>
          <option value="Asia/Pontianak">Asia/Pontianak</option>
          <option value="Asia/Pyongyang">Asia/Pyongyang</option>
          <option value="Asia/Qatar">Asia/Qatar</option>
          <option value="Asia/Qyzylorda">Asia/Qyzylorda</option>
          <option value="Asia/Rangoon">Asia/Rangoon</option>
          <option value="Asia/Riyadh">Asia/Riyadh</option>
          <option value="Asia/Sakhalin">Asia/Sakhalin</option>
          <option value="Asia/Samarkand">Asia/Samarkand</option>
          <option value="Asia/Seoul">Asia/Seoul</option>
          <option value="Asia/Shanghai">Asia/Shanghai</option>
          <option value="Asia/Singapore">Asia/Singapore</option>
          <option value="Asia/Taipei">Asia/Taipei</option>
          <option value="Asia/Tashkent">Asia/Tashkent</option>
          <option value="Asia/Tbilisi">Asia/Tbilisi</option>
          <option value="Asia/Tehran">Asia/Tehran</option>
          <option value="Asia/Thimphu">Asia/Thimphu</option>
          <option value="Asia/Tokyo">Asia/Tokyo</option>
          <option value="Asia/Ulaanbaatar">Asia/Ulaanbaatar</option>
          <option value="Asia/Urumqi">Asia/Urumqi</option>
          <option value="Asia/Vientiane">Asia/Vientiane</option>
          <option value="Asia/Vladivostok">Asia/Vladivostok</option>
          <option value="Asia/Yakutsk">Asia/Yakutsk</option>
          <option value="Asia/Yekaterinburg">Asia/Yekaterinburg</option>
          <option value="Asia/Yerevan">Asia/Yerevan</option>
          <option value="Atlantic/Azores">Atlantic/Azores</option>
          <option value="Atlantic/Bermuda">Atlantic/Bermuda</option>
          <option value="Atlantic/Canary">Atlantic/Canary</option>
          <option value="Atlantic/Cape_Verde">Atlantic/Cape_Verde</option>
          <option value="Atlantic/Faroe">Atlantic/Faroe</option>
          <option value="Atlantic/Madeira">Atlantic/Madeira</option>
          <option value="Atlantic/Reykjavik">Atlantic/Reykjavik</option>
          <option value="Atlantic/South_Georgia">Atlantic/South_Georgia</option>
          <option value="Atlantic/St_Helena">Atlantic/St_Helena</option>
          <option value="Atlantic/Stanley">Atlantic/Stanley</option>
          <option value="Europe/Amsterdam">Europe/Amsterdam</option>
          <option value="Europe/Andorra">Europe/Andorra</option>
          <option value="Europe/Athens">Europe/Athens</option>
          <option value="Europe/Belgrade">Europe/Belgrade</option>
          <option value="Europe/Berlin">Europe/Berlin</option>
          <option value="Europe/Bratislava">Europe/Bratislava</option>
          <option value="Europe/Brussels">Europe/Brussels</option>
          <option value="Europe/Bucharest">Europe/Bucharest</option>
          <option value="Europe/Budapest">Europe/Budapest</option>
          <option value="Europe/Chisinau">Europe/Chisinau</option>
          <option value="Europe/Copenhagen">Europe/Copenhagen</option>
          <option value="Europe/Dublin">Europe/Dublin</option>
          <option value="Europe/Gibraltar">Europe/Gibraltar</option>
          <option value="Europe/Guernsey">Europe/Guernsey</option>
          <option value="Europe/Helsinki">Europe/Helsinki</option>
          <option value="Europe/Isle_of_Man">Europe/Isle_of_Man</option>
          <option value="Europe/Istanbul">Europe/Istanbul</option>
          <option value="Europe/Jersey">Europe/Jersey</option>
          <option value="Europe/Kaliningrad">Europe/Kaliningrad</option>
          <option value="Europe/Kiev">Europe/Kiev</option>
          <option value="Europe/Lisbon">Europe/Lisbon</option>
          <option value="Europe/Ljubljana">Europe/Ljubljana</option>
          <option value="Europe/London">Europe/London</option>
          <option value="Europe/Luxembourg">Europe/Luxembourg</option>
          <option value="Europe/Madrid">Europe/Madrid</option>
          <option value="Europe/Malta">Europe/Malta</option>
          <option value="Europe/Mariehamn">Europe/Mariehamn</option>
          <option value="Europe/Minsk">Europe/Minsk</option>
          <option value="Europe/Monaco">Europe/Monaco</option>
          <option value="Europe/Moscow">Europe/Moscow</option>
          <option value="Europe/Oslo">Europe/Oslo</option>
          <option value="Europe/Paris">Europe/Paris</option>
          <option value="Europe/Podgorica">Europe/Podgorica</option>
          <option value="Europe/Prague">Europe/Prague</option>
          <option value="Europe/Riga">Europe/Riga</option>
          <option value="Europe/Rome">Europe/Rome</option>
          <option value="Europe/Samara">Europe/Samara</option>
          <option value="Europe/San_Marino">Europe/San_Marino</option>
          <option value="Europe/Sarajevo">Europe/Sarajevo</option>
          <option value="Europe/Simferopol">Europe/Simferopol</option>
          <option value="Europe/Skopje">Europe/Skopje</option>
          <option value="Europe/Sofia">Europe/Sofia</option>
          <option value="Europe/Stockholm">Europe/Stockholm</option>
          <option value="Europe/Tallinn">Europe/Tallinn</option>
          <option value="Europe/Tirane">Europe/Tirane</option>
          <option value="Europe/Uzhgorod">Europe/Uzhgorod</option>
          <option value="Europe/Vaduz">Europe/Vaduz</option>
          <option value="Europe/Vatican">Europe/Vatican</option>
          <option value="Europe/Vienna">Europe/Vienna</option>
          <option value="Europe/Vilnius">Europe/Vilnius</option>
          <option value="Europe/Volgograd">Europe/Volgograd</option>
          <option value="Europe/Warsaw">Europe/Warsaw</option>
          <option value="Europe/Zagreb">Europe/Zagreb</option>
          <option value="Europe/Zaporozhye">Europe/Zaporozhye</option>
          <option value="Europe/Zurich">Europe/Zurich</option>
          <option value="Indian/Antananarivo">Indian/Antananarivo</option>
          <option value="Indian/Chagos">Indian/Chagos</option>
          <option value="Indian/Christmas">Indian/Christmas</option>
          <option value="Indian/Cocos">Indian/Cocos</option>
          <option value="Indian/Comoro">Indian/Comoro</option>
          <option value="Indian/Kerguelen">Indian/Kerguelen</option>
          <option value="Indian/Mahe">Indian/Mahe</option>
          <option value="Indian/Maldives">Indian/Maldives</option>
          <option value="Indian/Mauritius">Indian/Mauritius</option>
          <option value="Indian/Mayotte">Indian/Mayotte</option>
          <option value="Indian/Reunion">Indian/Reunion</option>
          <option value="Pacific/Apia">Pacific/Apia</option>
          <option value="Pacific/Auckland">Pacific/Auckland</option>
          <option value="Pacific/Chatham">Pacific/Chatham</option>
          <option value="Pacific/Chuuk">Pacific/Chuuk</option>
          <option value="Pacific/Easter">Pacific/Easter</option>
          <option value="Pacific/Efate">Pacific/Efate</option>
          <option value="Pacific/Enderbury">Pacific/Enderbury</option>
          <option value="Pacific/Fakaofo">Pacific/Fakaofo</option>
          <option value="Pacific/Fiji">Pacific/Fiji</option>
          <option value="Pacific/Funafuti">Pacific/Funafuti</option>
          <option value="Pacific/Galapagos">Pacific/Galapagos</option>
          <option value="Pacific/Gambier">Pacific/Gambier</option>
          <option value="Pacific/Guadalcanal">Pacific/Guadalcanal</option>
          <option value="Pacific/Guam">Pacific/Guam</option>
          <option value="Pacific/Honolulu">Pacific/Honolulu</option>
          <option value="Pacific/Johnston">Pacific/Johnston</option>
          <option value="Pacific/Kiritimati">Pacific/Kiritimati</option>
          <option value="Pacific/Kosrae">Pacific/Kosrae</option>
          <option value="Pacific/Kwajalein">Pacific/Kwajalein</option>
          <option value="Pacific/Majuro">Pacific/Majuro</option>
          <option value="Pacific/Marquesas">Pacific/Marquesas</option>
          <option value="Pacific/Midway">Pacific/Midway</option>
          <option value="Pacific/Nauru">Pacific/Nauru</option>
          <option value="Pacific/Niue">Pacific/Niue</option>
          <option value="Pacific/Norfolk">Pacific/Norfolk</option>
          <option value="Pacific/Noumea">Pacific/Noumea</option>
          <option value="Pacific/Pago_Pago">Pacific/Pago_Pago</option>
          <option value="Pacific/Palau">Pacific/Palau</option>
          <option value="Pacific/Pitcairn">Pacific/Pitcairn</option>
          <option value="Pacific/Pohnpei">Pacific/Pohnpei</option>
          <option value="Pacific/Port_Moresby">Pacific/Port_Moresby</option>
          <option value="Pacific/Rarotonga">Pacific/Rarotonga</option>
          <option value="Pacific/Saipan">Pacific/Saipan</option>
          <option value="Pacific/Tahiti">Pacific/Tahiti</option>
          <option value="Pacific/Tarawa">Pacific/Tarawa</option>
          <option value="Pacific/Tongatapu">Pacific/Tongatapu</option>
          <option value="Pacific/Wake">Pacific/Wake</option>
          <option value="Pacific/Wallis">Pacific/Wallis</option>
        </select></td>
      <td>Your local timezone.</td>
    </tr>
    <tr>
      <th scope="row"><label for="siteName">Site Name *</label></th>
      <td><input name="siteName" id="siteNameInput" type="text" size="25" value="<?php echo $siteNameInput ?>" /></td>
      <td>Your Site Name <strong>(This will be used on the website)</strong></td>
    </tr>
    <tr>
      <th scope="row"><label for="tagLine">Tag Line</label></th>
      <td><input name="tagLine" id="tagLineInput" type="text" size="25" value="<?php echo $tagLineInput ?>" /></td>
      <td>A brief description of your site</td>
    </tr>
    <tr>
      <th scope="row"><label for="siteRoot">Site Root</label></th>
      <td><input name="siteRoot" id="siteRoot" type="text" size="25" value="<?php echo $siteRootInput ?>" /></td>
      <td>Example, if your domain is ndiaa.org then "http://www.ndiaa.org" is your site root.  If you are in a subdirectory like http://sites.google.com/site/ndiaa then "http://sites.google.com/site/ndiaa" is your root. </td>
    </tr>
    <tr>
      <td colspan="3"><p>Database connection details.</p></td>
    </tr>
    <tr>
      <th scope="row"><label for="dbname">Database Name *</label></th>
      <td><input name="dbname" id="dbname" type="text" size="25" value="<?php echo $dbnameInput ?>" /></td>
      <td>The name of the database you want to run SoberPress in. </td>
    </tr>
    <tr>
      <th scope="row"><label for="uname">User Name *</label></th>
      <td><input name="uname" id="uname" type="text" size="25" value="<?php echo $unameInput ?>" /></td>
      <td>Your MySQL username</td>
    </tr>
    <tr>
      <th scope="row"><label for="pwd">Password *</label></th>
      <td><input name="pwd" id="pwd" type="text" size="25" value="<?php echo $passwrdInput ?>" /></td>
      <td>...and MySQL password.</td>
    </tr>
    <tr>
      <th scope="row"><label for="dbhost">Database Host *</label></th>
      <td><input name="dbhost" id="dbhost" type="text" size="25" value="<?php echo $dbhostInput ?>" /></td>
      <td>You should be able to get this info from your web host, if <code>localhost</code> does not work.</td>
    </tr>
    <tr>
      <th scope="row"><label for="logo">Your Custom Logo</label>
        <br />
        <span style="color:#00F">(currently - <?php echo LOGO ?>)</span></th>
      <td><input name="logoNew" id="logoNew" type="file" value="" /></td>
      <td>This file should be 150px by 150px with a white or transparent background.</td>
    </tr>
    <tr>
      <th scope="row"><label for="tooltip">Tool Tips: </label></th>
      <?php if ($tooltipInput == 'ON'){$tooltipON = 'checked="checked"';}else{$tooltipOFF = 'checked="checked"';} ?>
      <td>
      	<input type="radio" title="tooltip" name="tooltip" id="tooltip_ON" <?php echo $tooltipON ?> value="ON"> ON
        <input type="radio" title="tooltip" name="tooltip" id="tooltip_OFF" <?php echo $tooltipOFF ?> value="OFF"> OFF</td>
      <td>Turn Tool Tips ON or OFF</td>
    </tr>
    <tr>
      <td align="center" colspan="3"><input name="submit" type="submit" value="Submit" class="groovybutton" /></td>
    </tr>
  </table>
</form>
<?php
	break;

	case 2:
	if(!get_magic_quotes_gpc()) {
		$orgname = addslashes(trim($_POST['orgname']));
		$apikey = addslashes(trim($_POST['apikey']));
		$siteRoot = addslashes(trim($_POST['siteRoot']));
		$timeZone = addslashes(trim($_POST['timeZone']));
		$siteName = addslashes(trim($_POST['siteName']));
		$tooltip = addslashes(trim($_POST['tooltip']));
		if(isset($_POST['tagLine'])) {
			$tagLine = addslashes(trim($_POST['tagLine']));
		}else{
			$tagLine ='';}
		$dbname  = addslashes(trim($_POST['dbname']));
		$uname   = addslashes(trim($_POST['uname']));
		$passwrd = addslashes(trim($_POST['pwd']));
		$dbhost  = addslashes(trim($_POST['dbhost']));
	}else{
		$orgname = trim($_POST['orgname']);
		$apikey = trim($_POST['apikey']);
		$siteRoot = trim($_POST['siteRoot']);
		$timeZone = trim($_POST['timeZone']);
		$siteName = trim($_POST['siteName']);
		$tooltip = trim($_POST['tooltip']);
		if(isset($_POST['tagLine'])) {
			$tagLine = trim($_POST['tagLine']);
		}else{
			$tagLine ='';}
		$dbname  = trim($_POST['dbname']);
		$uname   = trim($_POST['uname']);
		$passwrd = trim($_POST['pwd']);
		$dbhost  = trim($_POST['dbhost']);
		}

	// Test the db connection.

	// We'll fail here if the values are no good.
	$spdb = new mysqli($dbhost, $uname, $passwrd, $dbname);
	//$spdb = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	if ($spdb->connect_error) {
		$back = '<p class="step"><a href="setup-config.php?step=1" onclick="javascript:history.go(-1);return false;" class="button">Try Again</a></p>';
    	die('Connect Error: ' . $spdb->connect_error . $back);
	}
	// add http:// and a trailing slash if not http or https and/or no trailing slash
	$siteRoot = addhttp($siteRoot);
	
	// add any new logo files
	//set file name to current file name
	$fileName = constant ("LOGO");
	if($_FILES["logoNew"]["name"] != '') {
		// make sure the file is not bigger than 2MB
			if ($_FILES["logoNew"]["size"] > 2097152) {
			  echo "File must be no larger than 2MB";
			}
			// make sure there are no other file errors we didn't check for 
			if ($_FILES["logoNew"]["error"] > 0) { 
				echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
				echo '<a href="javascript: history.go(-1)">&nbsp;&lt;&lt;&nbsp;back</a>';
			}
		// move the replacement file to the events folder
		move_uploaded_file($_FILES["logoNew"]["tmp_name"], 
		APP_ROOT."/public_html/images/customlogos/" . $_FILES["logoNew"]["name"]);	
		$fileName = "customlogos/".$_FILES['logoNew']['name'];// now that the file is handled send just the name to the DB
	}
	list($width, $height, $type, $attr) = getimagesize(APP_ROOT."/public_html/images/".$fileName);
	echo $width.'<br />';
	echo $height;
	// reset line array pointer
	reset($line);
	foreach ($configFile as $line_num => $line) {
			switch (substr($line,0,16)) {
				case '$GLOBALS["ORG_NA':
					$configFile[$line_num] = str_replace($orgnameInput, $orgname, $line);
					break;
				case "define('DB_NAME'":
					$configFile[$line_num] = str_replace($dbnameInput, $dbname, $line);
					break;
				case "define('DB_USER'":
					$configFile[$line_num] = str_replace($unameInput, $uname, $line);
					break;
				case "define('DB_PASS'":
					$configFile[$line_num] = str_replace($passwrdInput, $passwrd, $line);
					break;
				case "define('DB_HOST'":
					$configFile[$line_num] = str_replace($dbhostInput, $dbhost, $line);
					break;
				case "define('API_KEY'":
					$configFile[$line_num] = str_replace($apikeyInput, $apikey, $line);
					break;
				case "date_default_tim":
					$configFile[$line_num] = str_replace($defaultTimeZoneInput, $timeZone, $line);
					break;
				case "define('TIME_ZON":
					$configFile[$line_num] = str_replace($timeZoneInput, $timeZone, $line);
					break;
				case "define('SITE_NAM":
					$configFile[$line_num] = str_replace($siteNameInput, $siteName, $line);
					break;
				case "define('SITE_DES":
					$configFile[$line_num] = str_replace($tagLineInput, $tagLine, $line);
					break;
				case "define('SITE_ROO":
					$configFile[$line_num] = str_replace($siteRootInput, $siteRoot, $line);
					break;
				case "define('LOGO', '":
					$configFile[$line_num] = str_replace(constant("LOGO"), $fileName, $line);
					break;
				case "define('LOGO_WID":
					$configFile[$line_num] = str_replace($widthInput, $width, $line);
					break;
				case "define('LOGO_HEI":
					$configFile[$line_num] = str_replace($heightInput, $height, $line);
					break;
				case "define('TOOL_TIP":
					$configFile[$line_num] = str_replace($tooltipInput, $tooltip, $line);
					break;	
							
			}
		}

	if ( ! is_writable(DIR_CONFIG) ) {
?>
<p>Sorry, but I can't write the <code>config.php</code> file.</p>
<p>You can create the <code>config.php</code> manually.</p>
<p>After you've done that, click "Run the install."</p>
<p class="step"><a href="setup-config.php" class="button">Run the install</a></p>
<?php
	}else{
		reset($line);
		$handle = fopen('../../config/config.php', 'w');
		foreach( $configFile as $line ) {
			fwrite($handle, $line);
		}
		fclose($handle);
		chmod('../../config/config.php', 0666);
?>
<script language="javascript" type="text/javascript">
	document.location.href='settings.php'
</script>
<?php
	}
	break;
}
?>
